{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["new instructions","Sheet2","SAF","Landscape","P 2 SUB CERT","SAF Attachment","SAF Add'l 2d Tier","drop down list","Potrait","Sheet1","Sheet3"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":9,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"new instructions","index":0,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[31,2,31,3],[55,1,55,2],[21,1,21,9],[31,6,31,7],[32,6,32,7],[34,1,34,9],[32,2,32,3],[30,4,30,5],[31,4,31,5],[32,4,32,5],[47,1,48,9],[57,1,57,2],[59,1,59,2],[61,1,61,2],[55,3,55,4],[57,3,57,4],[59,3,59,4],[61,3,61,4],[2,1,2,9],[4,1,4,9],[6,1,6,9],[8,1,8,9],[10,1,10,9],[14,1,14,9],[29,6,29,7],[30,6,30,7],[19,1,19,9],[29,2,29,3],[29,4,29,5],[30,2,30,3],[0,1,0,9],[50,0,50,3],[51,0,51,7],[52,0,52,9],[12,1,12,9],[44,1,44,9],[46,1,46,9],[15,1,15,9],[36,1,36,9],[38,1,38,9],[40,1,40,9],[42,1,42,9],[17,1,17,9],[27,1,27,9],[25,1,25,9],[23,1,23,9]]}
[null,"Subcontract Approval Form (SAF)"]
[]
["1.","Complete the \"Subcontract Approval Form\" (Form SAF) for the Subcontractor and the 2nd Tier Subcontractor on one form.  Additional items of work can be entered on the \"Subcontract Approval Form Attachment\".  If there is more than one 2nd Tier Subcontractor, the information should be listed on the \"Subcontract Approval Form - Additional 2nd Tier\" (SAF - Additonal 2nd Tier)."]
[]
["2.","Reporting Number is the Fiscal Vendor Number for Contractors and Subcontractors.  This number can be found in the NCDOT Directory of Transportation Firms - Prequalified Bidders and Subcontractors.  Use the following web address to access the list of Prequalified Bidders and Subcontractors."]
[]
[null,"https://partner.ncdot.gov/VendorDirectory/default.html"]
[]
[null,"Enter the name of your subcontractor and hit \"Submit\".  If the firm is prequalified to perform work for NCDOT, the firm's information will be shown on the screen.  Click on the firm's name to access the Reporting Number."]
[]
["3.","If retainage is being withheld for the Subcontractor or 2nd Tier Subcontractor place an \"X\" in the box under the column titled \"Retainage.\""]
[]
["4.","When the proposed Subcontractor or 2nd Tier Subcontractor is a certified DBE, MBE, or WBE Subcontractor, select the appropriate certification from the drop down list.  When the proposed Subcontractor is not a certified DBE, MBE, or WBE subcontractor, select \"NONE\" from the drop down list.  "]
[]
["5.","Partial Item of Work and Portion of Work"]
[null,"Partial Item of Work is defined as a Subcontractor performing part of the work associated with a line item, such as hauling asphalt or tying steel.  The partial item of work should be indicated by the symbol (♦).  The work associated with the contract line item to be performed by the Subcontractor shall be identified."]
[]
[null,"Portion of Work is defined as a Subcontractor performing all the work associated with a line item, but only a portion of the contract quantity.  An example is grading from Station 225+00 - L- to the end of the project.  The portions of work should be indicated by the symbol (●).  The physical limits of the sublet quantity shall be identified."]
[]
[null,"The Contractor may designate a subcontracted item of work as both a portion and a partial. (Example:  Contractor is subcontracting hauling of unclassified excavation to multiple trucking contractors.)  If the item of work is designated as both a portion and a partial the unit price shall be less than the contract unit price and the quantity shall be less than the contract quantity."]
[]
["6.","Sub or 2nd Tier - Designate if the work for the associated line item will be performed by a Subcontractor or a 2nd Tier Subcontractor.  This must be completed to correctly calculate the Subcontract Amount."]
[]
["7.","Units of Measure (UOM) shown on the Subcontract Approval Form (SAF) shall be the same as those shown in the Department's contract.  Any conversions that are necessary to satisfy this requirement shall be the responsibility of the Contractor.  The Converted Price (CP) shall be denoted with an asterisk (*).  (Examples of converting units of measure can be found in the HiCAMS User Guide, Chapter 2, Section 8A.  Use the following link to view the examples.)"]
[]
[null,"https://connect.ncdot.gov/projects/construction/Pages/HiCAMS-Manual.aspx"]
[]
["8.","DBE/MBE/WBE Unit Price - This unit price should only be completed for DBE/MBE/WBE Subcontractors.  Enter a DBE/MBE/WBE Unit Price for the items of work performed by any certified DBE/MBE/WBE.  Use the chart below to determine if a DBE/MBE/WBE Unit Price shall be entered for the line item, based on the certification of the firm."]
[]
[null,null,"Subcontractor",null,"2nd Tier",null,"Enter DBE/MBE/WBE\nUnit Price For"]
[null,null,"Certified ",null,"None",null,"Subcontractor"]
[null,null,"Certified ",null,"Certified",null,"Subcontractor"]
[null,null,"None",null,"Certified",null,"2nd Tier"]
[]
[null,"The DBE/MBE/WBE Unit Price must be the negotiated unit or lump sum price agreed upon between the Contractor and the Subcontractor, unless the Contractor is entering a Converted Price.   Indicating a Converted Price acknowledges that the price shown is not the actual price, but an approximate value used for calculating the Sublet Amount as reasonably close as possible.  It can be higher, lower or equal to the contract bid price."]
[]
["9.","DBE/MBE/WBE Sublet Amount is the DBE/MBE/WBE Unit Price multiplied by the Quantity.  For committed firms, the DBE/MBE/WBE Sublet Amount shall be the same or higher than the amount listed in the contract.  "]
[]
["10.","Subcontract Unit Price - The Subcontract Unit Price must be the same as the contract unit price unless the Subcontractor is performing a partial item of work.  When a partial item of work is sublet, the unit price must be less than the contract unit price.  When only a portion of the quantity of an item is sublet, the unit price shall be the same as the contract unit price.  If an item of work is designated as both a partial and a portion, refer to Item 5 of these instructions.  A Subcontract Unit Price must be entered for every line item, including an item of work performed by a DBE/MBE/WBE Subcontractor. "]
[]
["11.","The Total Subcontract Amount is the Subcontract Unit Price multiplied by the Quantity."]
[]
["12.","The Subcontract Amount is the amount subcontracted by the Contractor.  The amount is used to determine the percent of work performed by the Prime Contractor.  (Refer to Article 108-6 of the Standard Specifications for subletting percentages.)  The Subcontract Amount is calculated by summing the Total Subcontract Amounts for the Subcontractor.  Any items listed on the Attachment sheet for the Subcontractor is also included in the Subcontract Amount.  The line items for 2nd Tier Subcontractor(s) are not included."]
[]
["13.","When any item requested to be sublet has been previously included in an approved subcontract, the following statement shall be included above the listing of these items:  \"The following items are being deleted from \"Subcontract Request Number ____.\""]
[]
["14.","The Contractor, Subcontractor and 2nd Tier Subcontractor shall sign the original Subcontract Approval Form and the Contractor shall submit the form to the Resident Engineer."]
["15. ","By signing the Subcontract Approval Form, the contractor is in agreement that the FHWA 1273, \"Required Contract Provisions,\" (federal projects) and Title VI and Nondiscrimination Assurances (all projects) have been included in the subcontract / 2nd tier subcontract in its entirety."]
[]
[]
["Sublet Percentages"]
["FOR USE BY NCDOT PERSONNEL (for non HiCAMS contracts)"]
["The following is the process used to calculate the Sublet Percentages after the approval of each subcontract.  The fields will not populate, this process should be hand calculated."]
[]
[]
["(1)","Total Original Contract Amount",null,null,null,null,"(5)","Difference {1-(2+3)}"]
[]
["(2)","Specialty Items Sublet",null,null,null,null,"(6)","Percent by Prime {(1-4)/5"]
[]
["(3)","Non-spec. Items Sublet to DBE/MBE/WBE",null,null,null,null,"(7)","Threshold Check {(1-4)/(1-2)}"]
[]
["(4)","Total Sublet  (Grand Total)"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"SAF","index":2,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[2,0,2,11],[10,10,10,11],[14,10,14,11],[11,0,11,6],[42,4,42,5],[6,5,6,6],[6,9,6,10],[4,8,4,9],[4,3,4,4],[6,3,6,4],[4,5,4,6],[46,4,46,5],[38,4,38,5],[14,0,14,6],[11,10,11,11],[38,6,38,10],[41,6,41,11],[42,6,42,11],[43,6,43,11],[13,10,13,11]]}
["Form SAF Rev. 2A",null,null,null,null,null,null,null,null,null,null,"Rev. 04-2019"]
[]
["SUBCONTRACT APPROVAL FORM"]
[]
["Contract No.:",null,null,"F.A. No.: ",null,null,null,null,"Subcontract Request Number:"]
[]
["WBS Element:",null,null,"T.I.P. No.:",null,null,null,null,"County:"]
[]
["APPROVAL IS REQUESTED TO SUBLET THE FOLLOWING ITEMS OF WORK ON THIS PROJECT TO:"]
[]
[null,null,null,null,null,null,null,null,"Retainage","Certification","Reporting  No."]
[]
["Subcontractor Name and Address"]
[null,null,null,null,null,null,null,null,"Retainage","Certification","Reporting  No."]
[]
["2nd Tier-1 Subcontractor Name and Address"]
[]
["Line Code Number","Item Description","Portion\n(●)","Partial\n(♦) ","Sub\nor\n2nd Tier","Quantity","UOM","CP\n*","DBE/MBE/WBE\n Unit Price","DBE/MBE/WBE\n Sublet Amount","Subcontract\nUnit Price","Total Subcontract Amount"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F19*I19,2)","v":0},null,{"$f":"ROUND(F19*K19,2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F20*I20,2)","v":0},null,{"$f":"ROUND(F20*K20,2)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Indicates a Portion of Work (●)",null,null,"Indicates a Partial Item ( ♦ )",null,null,null,null,"DBE/MBE/WBE Amount",{"$f":"SUM(J19:J29)+'SAF Attachment'!J51+'SAF Add''l 2d Tier'!J30","v":0},"Subcontract Amt.",{"$f":"SUMIF(E19:E29,\"Sub\",L19:L29)+'SAF Attachment'!L51+'SAF Add''l 2d Tier'!L30","v":0}]
[]
["SUBCONTRACT CERTIFICATION (applies only to Federal projects)"]
["The Contractor / Subcontractor certifies that the subcontract is in writing and that FHWA 1273, \"Required Contract Provisions,\" and Title VI and "]
["Nondiscrimination Assurances have been included in the subcontract / 2nd tier subcontract in its entirety."]
["SUBCONTRACT CERTIFICATION (applies only to State projects)"]
["The Contractor / Subcontractor certifies that the subcontract is in writing and Title VI and Nondiscrimination Assurances have been  included in the"]
[" subcontract/2nd tier subcontract in its entirety."]
["Contractor:",null,null,null,null,null,"APPROVED:"]
["Signature:",null,null,"Date"]
["Title:",null,null,null,null,null,"Resident Engineer",null,null,null,null,"Date"]
[]
["Subcontractor:",null,null,null,null,null," Approved with the understanding that the Contractor will be responsible for the"]
["Signature:",null,null,"Date",null,null,"satisfactory performance and completion of the work in compliance with the "]
["Title:",null,null,null,null,null,"terms of the contract and that all payments will be made to the Contractor."]
[]
["2nd Tier Subcontractor:"]
["Signature:",null,null,"Date"]
["Title:"]

{"sheet":"Landscape","index":3,"n_rows":47,"n_cols":14,"rows_kept":47,"cut":false,"hidden":true,"merged":[[27,11,27,12],[26,11,26,12],[24,1,24,5],[35,5,35,6],[27,1,27,5],[25,1,25,5],[26,1,26,5],[28,11,28,12],[32,5,32,6],[29,11,29,12],[28,1,28,5],[32,11,32,12],[33,11,33,12],[34,11,34,12],[33,5,33,6],[34,5,34,6],[40,2,40,6],[40,8,40,10],[46,2,46,6],[41,2,41,6],[39,8,39,10],[39,2,39,6],[44,2,44,6],[45,2,45,6],[22,1,22,5],[23,1,23,5],[15,1,15,5],[16,1,16,5],[17,1,17,5],[18,1,18,5],[19,1,19,5],[20,1,20,5],[21,1,21,5],[15,11,15,12],[16,11,16,12],[1,1,1,10],[14,1,14,5],[3,9,3,10],[8,0,8,10],[11,0,11,10],[14,11,14,12],[17,11,17,12],[18,11,18,12],[25,11,25,12],[19,11,19,12],[21,11,21,12],[22,11,22,12],[20,11,20,12],[24,11,24,12],[23,11,23,12]]}
[]
[null,"REQUEST FOR SUBCONTRACT NUMBER ________"]
[]
["Contract No.:",null,null,null,"F.A. No.: ",null,null,null,"County:"]
["WBS Element:",null,null,null,"T.I.P. No.:"]
[]
["APPROVAL IS REQUESTED TO SUBLET THE FOLLOWING ITEMS OF WORK ON THIS PROJECT TO:"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DBE       MBE       WBE",null,"NONE"]
["Subcontractor Name and Address"]
[]
[null,null,null,null,null,null,null,null,null,null,null,"DBE       MBE       WBE",null,"NONE"]
["2nd Tier Subcontractor Name and Address"]
[]
["Line Code Number","Item Description",null,null,null,null,"Sub\nor\n2nd Tier","Quantity","Unit","Contract Unit Price","Subcontract Unit Price","Extended Subcontract Amount"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["Indicates a Portion of the Item (●)",null,null,null,null,"Indicates a Partial Item ( ♦ )",null,null,null,null,"Total:  "]
[]
["This Portion to be completed by the Resident Engineer:"]
["(1) Total Original Contract Amount",null,null,null,null,null,null,"(5) ","Difference {1-(2+3)}"]
["(2) Total Specialty  Items Sublet",null,null,null,null,null,null,"(6) ","Percent by Prime {(1-4)/5}"]
["(3) Non-Specialty Items Sublet to DBE/MB/WB",null,null,null,null,null,null,"(7) ","Threshold Check {(1-4)/(1-2)}"]
["(4) Total Sublet (Grand Total)"]
[]
[]
["SUBMITTED BY:",null,null,null,null,null,null,null,"APPROVED:"]
["Subcontractor:"]
["By:",null,null,null,null,null,null,null,"Resident Engineer",null,null,null,"Date"]
["Title:"]
[null,null,null,null,null,null,null,null," Approved with the understanding that the Contractor will be"]
["APPROVAL RECOMMENDED BY:",null,null,null,null,null,null,null," responsible for the satisfactory performance and completion "]
["Contractor:",null,null,null,null,null,null,null," of work in compliance with the terms of the contract and that "]
["By:",null,null,null,null,null,null,null," all payments will be made directly to the Contractor."]
["Title:"]

{"sheet":"P 2 SUB CERT","index":4,"n_rows":43,"n_cols":14,"rows_kept":43,"cut":false,"hidden":true,"merged":[[1,0,1,13],[29,8,29,13],[27,8,27,13],[28,8,28,13],[12,8,12,13],[13,8,13,13],[15,8,15,13],[42,0,42,4],[42,6,42,10],[3,3,3,6],[5,3,5,6],[4,3,4,6],[4,10,4,13],[3,10,3,13],[14,8,14,13],[10,2,10,4],[21,3,21,5],[41,0,41,4],[41,6,41,10],[16,8,16,13],[23,2,23,4],[25,8,25,13],[26,8,26,13]]}
[]
["SUBCONTRACT CERTIFICATION"]
["Complete for All Projects:"]
["1.","Contract Number:",null,null,null,null,null,"2. ","County:"]
["3.","Contractor:",null,null,null,null,null,"4. ","Subcontractor:"]
["5.","Date of Subcontract:"]
[]
[]
["Complete for Non-Federal-Aid Projects Only:"]
[]
["6.","I",null,null,null,"  certify that:",null,"(a)","The Subcontract Agreement is in writing."]
[]
[null,null,null,null,null,null,null,"(b)","I have made contact with potential Minority Business and"]
[null,null,null,null,null,null,null,null,"Women Business Subcontractors and affirmatively solicited"]
[null,null,null,null,null,null,null,null,"their interest, capability, and prices in conjunction with"]
[null,null,null,null,null,null,null,null,"this Subcontract and have documented the results of such "]
[null,null,null,null,null,null,null,null,"contracts."]
[]
[]
["Complete for Federal-Aid Projects Only:"]
[]
["7.","Federal-Aid Number:"]
[]
["8.","I",null,null,null,"  certify that:",null,"(a)","The Subcontract Agreement is in writing."]
[]
[null,null,null,null,null,null,null,"(b)","I have made contact with potential Disadvantaged Business "]
[null,null,null,null,null,null,null,null,"Enterprise Subcontractors and affirmatively solicited their"]
[null,null,null,null,null,null,null,null,"interest, capability, and prices in conjunction with this"]
[null,null,null,null,null,null,null,null,"Subcontract and have documented the results of such "]
[null,null,null,null,null,null,null,null,"contracts."]
[]
["9.","The following items are applicable to subcontracts of",null,null,null,null,null,"(a)","Notice concerning certifications of non-segregated facilities."]
[null,"$10,000.00 or more on projects that contain Federal-Aid",null,null,null,null,null,"(b)","Form FHWA ___________ , \"Required Contactor Provisions.\""]
[null,"Regulations and have been attached to and made a",null,null,null,null,null,"(c)","\"Specific Equal Opportunity Responsibilities.\""]
[null,"part of this Subcontract.",null,null,null,null,null,"(d)","\"Training Special Provisions.\""]
[null,null,null,null,null,null,null,"(e)","All other required Federal-Aid regulations contained in the "]
[null,null,null,null,null,null,null,null,"contract."]
[]
[]
["Complete for All Projects:"]
[]
[]
["Contractor's Representative",null,null,null,null,null,"Representative's Title",null,null,null,null,null,null,"Date"]

{"sheet":"SAF Attachment","index":5,"n_rows":51,"n_cols":12,"rows_kept":51,"cut":false,"hidden":false,"merged":[[6,3,6,4],[6,5,6,6],[6,8,6,9],[4,0,4,11]]}
["Form SAF Attachment Rev. 2A",null,null,null,null,null,null,null,null,null,null,"Rev. 04-2019"]
[]
[]
[]
[" SUBCONTRACT APPROVAL FORM"]
[]
["Contract No.:",{"$f":"SAF!C5","v":0},null,"F.A. No.: ",null,{"$f":"SAF!F5","v":0},null,null,"Subcontract Request Number:"]
[]
["Line Code Number","Item Description","Portion\n(●)","Partial\n(♦) ","Sub\nor\n2nd Tier","Quantity","UOM","CP\n*","DBE/MBE/WBE\n Unit Price","DBE/MBE/WBE\n Sublet Amount","Subcontract\nUnit Price","Total Subcontract Amount"]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F10*I10,2)","v":0},null,{"$f":"ROUND(F10*K10,2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F11*I11,2)","v":0},null,{"$f":"ROUND(F11*K11,2)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Indicates a Portion ofWork (●)",null,null,"Indicates a Partial Item ( ♦ )"]
[null,null,null,null,null,null,null,null,"DBE/MBE/WBE Amount",{"$f":"SUM(J10:J49)","v":0},"Subcontract Amt.",{"$f":"SUMIF(E10:E49,\"Sub\",L10:L49)","v":0}]

{"sheet":"SAF Add'l 2d Tier","index":6,"n_rows":48,"n_cols":12,"rows_kept":48,"cut":false,"hidden":false,"merged":[[12,10,12,11],[9,10,9,11],[13,10,13,11],[10,10,10,11],[2,0,2,11],[10,0,10,6],[13,0,13,6],[4,3,4,4],[4,5,4,6],[4,8,4,9],[6,3,6,4],[6,5,6,6],[6,9,6,10],[43,6,43,11],[38,4,38,5],[42,4,42,5],[46,4,46,5],[38,6,38,10],[41,6,41,11],[42,6,42,11]]}
["Form SAF Additional 2nd Tier Rev. 2A",null,null,null,null,null,null,null,null,null,null,"Rev. 04-2019"]
[]
[" SUBCONTRACT APPROVAL FORM"]
[]
["Contract No.:",null,null,"F.A. No.: ",null,null,null,null,"Subcontract Request Number:"]
[]
["WBS Element:",null,null,"T.I.P. No.:",null,null,null,null,"County:"]
[]
["APPROVAL IS REQUESTED TO SUBLET THE FOLLOWING ITEMS OF WORK ON THIS PROJECT TO:"]
[null,null,null,null,null,null,null,null,"Retainage","Certification","Reporting  No."]
[]
["2nd Tier-2 Subcontractor Name and Address"]
[null,null,null,null,null,null,null,null,"Retainage","Certification","Reporting  No."]
[]
["2nd Tier-3 Subcontractor Name and Address"]
[]
["Line Code Number","Item Description","Portion\n(●)","Partial\n(♦) ","Sub\nor\n2nd Tier","Quantity","UOM","CP\n*","DBE/MBE/WBE\n Unit Price","DBE/MBE/WBE\n Sublet Amount","Subcontract\nUnit Price","Total Subcontract Amount"]
[null,"lll",null,null,null,null,null,null,null,{"$f":"ROUND(F18*I18,2)","v":0},null,{"$f":"ROUND(F18*K18,2)","v":0}]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(F19*I19,2)","v":0},null,{"$f":"ROUND(F19*K19,2)","v":0}]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
[null,null,null,null,null,null,null,null,null,0,null,0]
["Indicates a Portion of Work (●)",null,null,"Indicates a Partial Item ( ♦ )"]
[null,null,null,null,null,null,null,null,"DBE/MBE/WBE Amount",{"$f":"SUM(J18:J28)","v":0},"Subcontract Amt.",{"$f":"SUMIF(E18:E28,\"Sub\",L18:L28)","v":0}]
[]
["SUBCONTRACT CERTIFICATION (applies only to Federal projects)"]
["The Contractor / Subcontractor certifies that the subcontract is in writing and that FHWA 1273, \"Required Contract Provisions,\" and Title VI and "]
["Nondiscrimination Assurances have been included in the subcontract / 2nd tier subcontract in its entirety."]
["SUBCONTRACT CERTIFICATION (applies only to State projects)"]
["The Contractor / Subcontractor certifies that the subcontract is in writing and Title VI and Nondiscrimination Assurances have been  included in the"]
[" subcontract/2nd tier subcontract in its entirety."]
["Contractor:",null,null,null,null,null,"APPROVED:"]
["Signature:",null,null,"Date"]
["Title:",null,null,null,null,null,"Resident Engineer",null,null,null,null,"Date"]
[]
["Subcontractor:",null,null,null,null,null," Approved with the understanding that the Contractor will be responsible for the "]
["Signature:",null,null,"Date",null,null,"satisfactory performance and completion of the work in compliance with the "]
["Title:",null,null,null,null,null," terms of the contract and that all payments will be made directly to the Contractor."]
[]
["2nd Tier Subcontractor:"]
["Signature:",null,null,"Date"]
["Title:"]

{"sheet":"drop down list","index":7,"n_rows":14,"n_cols":1,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
["Sub"]
["2nd Tier-1"]
["2nd Tier-2"]
["2nd Tier-3"]
[]
[]
[]
["●"]
["♦"]
[]
["DBE"]
["MBE"]
["WBE"]
["NONE"]

{"sheet":"Potrait","index":8,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":true,"merged":[[1,0,1,8],[11,0,11,6],[8,0,8,6]]}
[]
["REQUEST FOR SUBCONTRACT NUMBER ________"]
[]
["Contract No.:",null,null,"F.A. No.: ",null,null,"County:"]
["WBS Element:",null,null,"T.I.P. No.:"]
[]
["APPROVAL IS REQUESTED TO SUBLET THE FOLLOWING ITEMS OF WORK ON THIOS PROJECT TO:"]
[]
[null,null,null,null,null,null,null,"DBE       MBE       WBE"]
["Subcontractor Name and Address"]
[]
[null,null,null,null,null,null,null,"DBE       MBE       WBE"]
["2nd Tier Subcontractor Name and Address"]

{"sheet":"Sheet1","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Sheet3","index":10,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}